﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;


namespace Petaframe.DataAccess.IntegrationTests
{
    [TableName("Categories")]
    class Category
    {
        [TablePrimaryKey(TablePrimaryKeyName= "", AutoIncrement = true)]
        public decimal CategoryID { get; set; }

        public string CategoryName { get; set; }

        public string Description { get; set; }
    }

    [TableName("PRODUCTS")]
    public class Products
    {
        [TablePrimaryKey(AutoIncrement = true)]
        public int ProductID { get; set; }
        public string ProductName { get; set; }
        public int SupplierID { get; set; }
        public int CategoryID { get; set; }
        public decimal UnitPrice { get; set; }
    }

    //oracledataserviste kullanmak için
    [TableName("PRODUCTS")]
    public class Products2
    {
        //oracle datareader int tiplerini decimal olarak okuyor. 
        [TablePrimaryKey(AutoIncrement = true)]
        public decimal ProductID { get; set; }

        public decimal SupplierID { get; set; }
        public decimal CategoryID { get; set; }
        public double UnitPrice { get; set; }
    }
}
